根据某列最大值查询最大值所在的这一行

select * from FA_DepreCrecentialsDetail as a
where UsedMonth = (select max(b.UsedMonth)
from FA_DepreCrecentialsDetail as b
where a.Code = b.Code)